Michael Culley ✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	19

About Me

About Me

Not much happening here, yet.

Analytics

288

Posts

235

Visits

547

Points

Oct 31, 2018

Join Date

Jan 31, 2025

Last Active

Reactions

• Promote 1

  1
• Insightful 4

  4
• Vote Up 15

  15
• Awesome 23

  23

• Activity
• Discussions15
• Comments273

• Re: How to create reports according to the Month

  Michael Culley

  10/12/22
  I would do: =IF(MONTH(TODAY()) + 3 > 12, MONTH(TODAY()) + 3 - 12, MONTH(TODAY()) + 3) =IF(MONTH(TODAY()) + 4 > 12, MONTH(TODAY()) + 4 - 12, MONTH(TODAY()) + 4) etc etc
  1 ·

• Re: Complicated IF Formula

  Michael Culley

  10/12/22
  =if(and([constant column]9 > [constant column]8,[constant column]9 >[constant column]7,[constant column]7<1),"Green", if(and([constant column]8>[constant column]9,[constant colu…
  1 ·

• Re: Complicated IF Formula

  Michael Culley

  10/12/22
  I would do something like: =if(and([constant column]3 > [constant column]2,[constant column]3 >[constant column]1,[constant column]1<1),"Green", if(and([constant column]2>[const…
  1 ·

• Re: Complicated IF Formula

  Michael Culley

  10/12/22
  Basically it says if Total SI is greater than Total PIOP AND greater than NYIOP AND NYIOP is less than 1, Green. If Total PIOP is greater than Total SI AND greater than NYIOP, Yellow. Anything else, …
  1 ·

• Re: Complicated IF Formula

  Michael Culley

  10/12/22
  Sorry I just noticed that you labeled the rows 7, 8, 9 so change my column numbers accordingly.
  1 ·

Previous Next